package com.bkgy.controller.completeflow.dao;

import com.bkgy.controller.completeflow.entity.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;


/**
 * Author:
 * Description:
 *
 * @Date:Created In 11:00 2025/5/13
 */
@Mapper
public interface CompleteFlowDao {

    //按天查询2280酸轧线成材率表 成材率
    List<CompleteFlowAcid> queryTcmByDay(@Param("query") CompleteFlowRequest query);
    //按月查询2280酸轧线成材率表 成材率
    List<CompleteFlowAcid> queryTcmByMonth(@Param("query") CompleteFlowRequest query);
    //按天查询1870镀锌线成材率表 成材率
    /**
     * 1870成才率 按日检索
     * @param query CompleteFlowRequest
     * @return List<CompleteFlowAcid>
     */
    List<CompleteFlowAcid> queryCglByDay(@Param("query") CompleteFlowRequest query);
    //按月查询1870镀锌线成材率表 成材率
    /**
     * 1870重卷成才率 按日检索
     * @param query CompleteFlowRequest
     * @return List<CompleteFlowAcid>
     */
    List<CompleteFlowAcid>queryCalRcl1870ByDay(@Param("query") CompleteFlowRequest query);

    /**
     * 1870成才率 按月检索
     * @param query CompleteFlowRequest
     * @return List<CompleteFlowAcid>
     */
    List<CompleteFlowAcid> queryCglByMonth(@Param("query") CompleteFlowRequest query);
    //按天查询1630连退线成材率表 成材率
    /**
     * 1870成才率 按月检索
     * @param query CompleteFlowRequest
     * @return List<CompleteFlowAcid>
     */
    List<CompleteFlowAcid>queryCalRcl1870ByMonth(@Param("query") CompleteFlowRequest query);

    /**
     * 1630成材率 按日检索
     * @param query CompleteFlowRequest
     * @return List<CompleteFlowAcid>
     */
    List<CompleteFlowAcid> queryCal1630ByDay(@Param("query") CompleteFlowRequest query);
    //按月查询1630连退线成材率表 成材率
    /**
     * 1630重卷成材率 按日检索
     * @param query CompleteFlowRequest
     * @return List<CompleteFlowAcid>
     */
    List<CompleteFlowAcid> queryCalRcl1630ByDay(@Param("query") CompleteFlowRequest query);

    /**
     * 1630成材率 按月检索
     * @param query CompleteFlowRequest
     * @return List<CompleteFlowAcid>
     */
    List<CompleteFlowAcid> queryCal1630ByMonth(@Param("query") CompleteFlowRequest query);
    //按天查询2150 连退线成材率表 成材率
    /**
     * 1630重卷成材率 按月检索
     * @param query CompleteFlowRequest
     * @return List<CompleteFlowAcid>
     */
    List<CompleteFlowAcid>queryCalRcl1630ByMonth(@Param("query") CompleteFlowRequest query);

    /**
     * 2150成材率 按日检索
     * @param query CompleteFlowRequest
     * @return List<CompleteFlowAcid>
     */
    List<CompleteFlowAcid> queryCal2150ByDay(@Param("query") CompleteFlowRequest query);
    //按月查询2150 连退线成材率表 成材率
    /**
     * 2150重卷成材率 按日检索
     * @param query CompleteFlowRequest
     * @return List<CompleteFlowAcid>
     */
    List<CompleteFlowAcid> queryCalRcl2150ByDay(@Param("query") CompleteFlowRequest query);

    /**
     * 2150成材率 按月检索
     * @param query CompleteFlowRequest
     * @return List<CompleteFlowAcid>
     */
    List<CompleteFlowAcid> queryCal2150ByMonth(@Param("query") CompleteFlowRequest query);

    /**
     * 2150重卷成材率 按月检索
     * @param query CompleteFlowRequest
     * @return List<CompleteFlowAcid>
     */
    List<CompleteFlowAcid> queryCalRcl2150ByMonth(@Param("query") CompleteFlowRequest query);

    /**
     * 全流程成材率分析班组统计
     * @param request CompleteFlowRequest
     * @return List<CompleteFlowCrew>
     */
    //查询2280酸轧线成材率表 班组、品规信息
    List<CompleteFlowCrew> queryCrewTcm(@Param("query") CompleteFlowRequest request);
    //查询1870镀锌线成材率表 班组、品规信息
    List<CompleteFlowCrew> queryCrewCgl(@Param("query") CompleteFlowRequest request);
    //查询1630连退线成材率表 班组、品规信息
    List<CompleteFlowCrew> queryCrewCal1630(@Param("query") CompleteFlowRequest request);
    //查询2150 连退线成材率表 班组、品规信息
    List<CompleteFlowCrew> queryCrewCal2150(@Param("query") CompleteFlowRequest request);
    //RCL1630 连退线成材率表 班组、品规信息
    List<CompleteFlowCrew> queryCrewRcl1630(@Param("query") CompleteFlowRequest request);
    //RCL2150 连退线成材率表 班组、品规信息
    List<CompleteFlowCrew> queryCrewRcl2150(@Param("query") CompleteFlowRequest request);
    //RCL1870 连退线成材率表 班组、品规信息
    List<CompleteFlowCrew> queryCrewRcl1870(@Param("query") CompleteFlowRequest request);

    //查询2280 线成材率表 品规信息
    List<CompleteFlowSpeci> querySpeciTcm(@Param("query") CompleteFlowRequest request);
    //查询1870 线成材率表 班组、品规信息
    List<CompleteFlowSpeci> querySpeciCgl(@Param("query") CompleteFlowRequest request);
    //查询1630 线成材率表 班组、品规信息
    List<CompleteFlowSpeci> querySpeciCal1630(@Param("query") CompleteFlowRequest request);
    //查询2150 线成材率表 班组、品规信息
    List<CompleteFlowSpeci> querySpeciCal2150(@Param("query") CompleteFlowRequest request);
    //Rcl2150 线成材率表 班组、品规信息
    List<CompleteFlowSpeci> querySpeciRcl2150(@Param("query") CompleteFlowRequest request);
    //Rcl1630 线成材率表 班组、品规信息
    List<CompleteFlowSpeci> querySpeciRcl1630(@Param("query") CompleteFlowRequest request);
    //Rcl1870 线成材率表 班组、品规信息
    List<CompleteFlowSpeci> querySpeciRcl1870(@Param("query") CompleteFlowRequest request);

    /**
     * 全流程损失指标统计
     * @param request CompleteFlowRequest
     * @return List<CompleteFlowLoss>
     */
    //查询2280酸轧线损失比
    List<CompleteFlowLoss> queryLossTcm(@Param("query") CompleteFlowRequest request);
    //查询1870镀锌线损失比
    List<CompleteFlowLoss> queryLossCgl(@Param("query") CompleteFlowRequest request);
    //查询1630连退线损失比
    List<CompleteFlowLoss> queryLossCal1630(@Param("query") CompleteFlowRequest request);
    //查询2150 连退线损失比
    List<CompleteFlowLoss> queryLossCal2150(@Param("query") CompleteFlowRequest request);
    //重卷2150 损失比
    List<CompleteFlowLoss> queryLossRcl2150(@Param("query") CompleteFlowRequest request);
    //重卷1630 损失比
    List<CompleteFlowLoss> queryLossRcl1630(@Param("query") CompleteFlowRequest request);
    //重卷1870 损失比
    List<CompleteFlowLoss> queryLossRcl1870(@Param("query") CompleteFlowRequest request);
}




